package com.zhang.bingmei_incomeexpenditure.entity.Utils;

import com.zhang.bingmei_incomeexpenditure.entity.ie.*;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;

/**
 * 收支数据测试硬编码工具类（year字段改为int类型）
 * 用于测试类直接获取预设的 IncomeExpenditureResult2 数据
 */
public class IncomeExpenditureTestDataUtil {

    /**
     * 获取硬编码的收支数据结果
     * @return IncomeExpenditureResult2 包含列表数据和合计数据
     */
    public static IncomeExpenditureResult2 getTestResultData() {
        IncomeExpenditureResult2 result = new IncomeExpenditureResult2();

        // 1. 硬编码列表数据：incomeExpenditureExportVOList（year改为int类型）
        List<IncomeExpenditureExportVO> exportVOList = new ArrayList<>();

        // 第1条数据：秀英区 2024
        IncomeExpenditureExportVO vo1 = new IncomeExpenditureExportVO();
        vo1.setDistrict("秀英区");
        vo1.setYear(2024); // 改为int类型，移除引号
        vo1.setCityAllocated(0L);
        vo1.setDistrictAllocated(3L);
        vo1.setOtherFunds(2L);
        vo1.setTotalFunds(5L);
        vo1.setPurchaseMaintain(5L);
        vo1.setPurchaseEquipment(5L);
        vo1.setDiseasePrevention(0L);
        vo1.setExpertTraining(1L);
        vo1.setThirdPartyService(25L);
        vo1.setOtherPayment(5L);
        vo1.setTotalPayment(41L);
        vo1.setCityRecovered(51000L);
        vo1.setDistrictRecovered(20500L);
        exportVOList.add(vo1);

        // 第2条数据：乐东黎族自治县 2025
        IncomeExpenditureExportVO vo2 = new IncomeExpenditureExportVO();
        vo2.setDistrict("乐东黎族自治县");
        vo2.setYear(2025); // int类型
        vo2.setCityAllocated(510000L);
        vo2.setDistrictAllocated(305000L);
        vo2.setOtherFunds(205000L);
        vo2.setTotalFunds(1020000L);
        vo2.setPurchaseMaintain(155000L);
        vo2.setPurchaseEquipment(205000L);
        vo2.setDiseasePrevention(82000L);
        vo2.setExpertTraining(122000L);
        vo2.setThirdPartyService(255000L);
        vo2.setOtherPayment(51000L);
        vo2.setTotalPayment(870000L);
        vo2.setCityRecovered(51000L);
        vo2.setDistrictRecovered(20500L);
        exportVOList.add(vo2);

        // 第3条数据：临高县 2024
        IncomeExpenditureExportVO vo3 = new IncomeExpenditureExportVO();
        vo3.setDistrict("临高县");
        vo3.setYear(2024); // int类型
        vo3.setCityAllocated(440000L);
        vo3.setDistrictAllocated(999999L);
        vo3.setOtherFunds(165000L);
        vo3.setTotalFunds(1604999L);
        vo3.setPurchaseMaintain(129000L);
        vo3.setPurchaseEquipment(185000L);
        vo3.setDiseasePrevention(68000L);
        vo3.setExpertTraining(98000L);
        vo3.setThirdPartyService(215000L);
        vo3.setOtherPayment(41000L);
        vo3.setTotalPayment(736000L);
        vo3.setCityRecovered(44000L);
        vo3.setDistrictRecovered(16500L);
        exportVOList.add(vo3);

        // 第4条数据：临高县 2025
        IncomeExpenditureExportVO vo4 = new IncomeExpenditureExportVO();
        vo4.setDistrict("临高县");
        vo4.setYear(2025); // int类型
        vo4.setCityAllocated(460000L);
        vo4.setDistrictAllocated(285000L);
        vo4.setOtherFunds(175000L);
        vo4.setTotalFunds(920000L);
        vo4.setPurchaseMaintain(135000L);
        vo4.setPurchaseEquipment(195000L);
        vo4.setDiseasePrevention(72000L);
        vo4.setExpertTraining(102000L);
        vo4.setThirdPartyService(225000L);
        vo4.setOtherPayment(45000L);
        vo4.setTotalPayment(774000L);
        vo4.setCityRecovered(46000L);
        vo4.setDistrictRecovered(17500L);
        exportVOList.add(vo4);

        // 第5条数据：陵水黎族自治县 2024
        IncomeExpenditureExportVO vo5 = new IncomeExpenditureExportVO();
        vo5.setDistrict("陵水黎族自治县");
        vo5.setYear(2024); // int类型
        vo5.setCityAllocated(540000L);
        vo5.setDistrictAllocated(315000L);
        vo5.setOtherFunds(225000L);
        vo5.setTotalFunds(1080000L);
        vo5.setPurchaseMaintain(164000L);
        vo5.setPurchaseEquipment(215000L);
        vo5.setDiseasePrevention(87000L);
        vo5.setExpertTraining(127000L);
        vo5.setThirdPartyService(275000L);
        vo5.setOtherPayment(54000L);
        vo5.setTotalPayment(922000L);
        vo5.setCityRecovered(54000L);
        vo5.setDistrictRecovered(22500L);
        exportVOList.add(vo5);

        // 第6条数据：陵水黎族自治县 2025
        IncomeExpenditureExportVO vo6 = new IncomeExpenditureExportVO();
        vo6.setDistrict("陵水黎族自治县");
        vo6.setYear(2025); // int类型
        vo6.setCityAllocated(560000L);
        vo6.setDistrictAllocated(325000L);
        vo6.setOtherFunds(235000L);
        vo6.setTotalFunds(1120000L);
        vo6.setPurchaseMaintain(170000L);
        vo6.setPurchaseEquipment(225000L);
        vo6.setDiseasePrevention(89000L);
        vo6.setExpertTraining(132000L);
        vo6.setThirdPartyService(285000L);
        vo6.setOtherPayment(56000L);
        vo6.setTotalPayment(957000L);
        vo6.setCityRecovered(56000L);
        vo6.setDistrictRecovered(23500L);
        exportVOList.add(vo6);

        // 第7条数据：琼海市 2024
        IncomeExpenditureExportVO vo7 = new IncomeExpenditureExportVO();
        vo7.setDistrict("琼海市");
        vo7.setYear(2024); // int类型
        vo7.setCityAllocated(590000L);
        vo7.setDistrictAllocated(345000L);
        vo7.setOtherFunds(245000L);
        vo7.setTotalFunds(1180000L);
        vo7.setPurchaseMaintain(179000L);
        vo7.setPurchaseEquipment(245000L);
        vo7.setDiseasePrevention(97000L);
        vo7.setExpertTraining(147000L);
        vo7.setThirdPartyService(315000L);
        vo7.setOtherPayment(64000L);
        vo7.setTotalPayment(1047000L);
        vo7.setCityRecovered(59000L);
        vo7.setDistrictRecovered(24500L);
        exportVOList.add(vo7);

        // 第8条数据：琼海市 2025
        IncomeExpenditureExportVO vo8 = new IncomeExpenditureExportVO();
        vo8.setDistrict("琼海市");
        vo8.setYear(2025); // int类型
        vo8.setCityAllocated(610000L);
        vo8.setDistrictAllocated(355000L);
        vo8.setOtherFunds(255000L);
        vo8.setTotalFunds(1220000L);
        vo8.setPurchaseMaintain(185000L);
        vo8.setPurchaseEquipment(255000L);
        vo8.setDiseasePrevention(99000L);
        vo8.setExpertTraining(152000L);
        vo8.setThirdPartyService(325000L);
        vo8.setOtherPayment(66000L);
        vo8.setTotalPayment(1082000L);
        vo8.setCityRecovered(61000L);
        vo8.setDistrictRecovered(25500L);
        exportVOList.add(vo8);

        // 第9条数据：琼中黎族苗族自治县 2024
        IncomeExpenditureExportVO vo9 = new IncomeExpenditureExportVO();
        vo9.setDistrict("琼中黎族苗族自治县");
        vo9.setYear(2024); // int类型
        vo9.setCityAllocated(470000L);
        vo9.setDistrictAllocated(285000L);
        vo9.setOtherFunds(185000L);
        vo9.setTotalFunds(940000L);
        vo9.setPurchaseMaintain(132000L);
        vo9.setPurchaseEquipment(192000L);
        vo9.setDiseasePrevention(74000L);
        vo9.setExpertTraining(104000L);
        vo9.setThirdPartyService(232000L);
        vo9.setOtherPayment(44000L);
        vo9.setTotalPayment(778000L);
        vo9.setCityRecovered(47000L);
        vo9.setDistrictRecovered(18500L);
        exportVOList.add(vo9);

        // 第10条数据：琼中黎族苗族自治县 2025
        IncomeExpenditureExportVO vo10 = new IncomeExpenditureExportVO();
        vo10.setDistrict("琼中黎族苗族自治县");
        vo10.setYear(2025); // int类型
        vo10.setCityAllocated(490000L);
        vo10.setDistrictAllocated(295000L);
        vo10.setOtherFunds(195000L);
        vo10.setTotalFunds(980000L);
        vo10.setPurchaseMaintain(140000L);
        vo10.setPurchaseEquipment(200000L);
        vo10.setDiseasePrevention(78000L);
        vo10.setExpertTraining(108000L);
        vo10.setThirdPartyService(240000L);
        vo10.setOtherPayment(48000L);
        vo10.setTotalPayment(814000L);
        vo10.setCityRecovered(49000L);
        vo10.setDistrictRecovered(19500L);
        exportVOList.add(vo10);

        // 第11条数据：三沙市 2024
        IncomeExpenditureExportVO vo11 = new IncomeExpenditureExportVO();
        vo11.setDistrict("三沙市");
        vo11.setYear(2024); // int类型
        vo11.setCityAllocated(690000L);
        vo11.setDistrictAllocated(395000L);
        vo11.setOtherFunds(195000L);
        vo11.setTotalFunds(1280000L);
        vo11.setPurchaseMaintain(199000L);
        vo11.setPurchaseEquipment(295000L);
        vo11.setDiseasePrevention(119000L);
        vo11.setExpertTraining(179000L);
        vo11.setThirdPartyService(345000L);
        vo11.setOtherPayment(79000L);
        vo11.setTotalPayment(1216000L);
        vo11.setCityRecovered(69000L);
        vo11.setDistrictRecovered(19500L);
        exportVOList.add(vo11);

        // 第12条数据：龙华区 2024
        IncomeExpenditureExportVO vo12 = new IncomeExpenditureExportVO();
        vo12.setDistrict("龙华区");
        vo12.setYear(2024); // int类型
        vo12.setCityAllocated(610000L);
        vo12.setDistrictAllocated(888888L);
        vo12.setOtherFunds(255000L);
        vo12.setTotalFunds(1753888L);
        vo12.setPurchaseMaintain(185000L);
        vo12.setPurchaseEquipment(225000L);
        vo12.setDiseasePrevention(92000L);
        vo12.setExpertTraining(152000L);
        vo12.setThirdPartyService(305000L);
        vo12.setOtherPayment(62000L);
        vo12.setTotalPayment(1021000L);
        vo12.setCityRecovered(61000L);
        vo12.setDistrictRecovered(25500L);
        exportVOList.add(vo12);

        // 第13条数据：三沙市 2025
        IncomeExpenditureExportVO vo13 = new IncomeExpenditureExportVO();
        vo13.setDistrict("三沙市");
        vo13.setYear(2025); // int类型
        vo13.setCityAllocated(710000L);
        vo13.setDistrictAllocated(405000L);
        vo13.setOtherFunds(205000L);
        vo13.setTotalFunds(1320000L);
        vo13.setPurchaseMaintain(205000L);
        vo13.setPurchaseEquipment(305000L);
        vo13.setDiseasePrevention(122000L);
        vo13.setExpertTraining(185000L);
        vo13.setThirdPartyService(355000L);
        vo13.setOtherPayment(85000L);
        vo13.setTotalPayment(1257000L);
        vo13.setCityRecovered(71000L);
        vo13.setDistrictRecovered(20500L);
        exportVOList.add(vo13);

        // 第14条数据：三亚市 2024
        IncomeExpenditureExportVO vo14 = new IncomeExpenditureExportVO();
        vo14.setDistrict("三亚市");
        vo14.setYear(2024); // int类型
        vo14.setCityAllocated(790000L);
        vo14.setDistrictAllocated(99999L);
        vo14.setOtherFunds(245000L);
        vo14.setTotalFunds(1134999L);
        vo14.setPurchaseMaintain(219000L);
        vo14.setPurchaseEquipment(315000L);
        vo14.setDiseasePrevention(129000L);
        vo14.setExpertTraining(199000L);
        vo14.setThirdPartyService(395000L);
        vo14.setOtherPayment(89000L);
        vo14.setTotalPayment(1346000L);
        vo14.setCityRecovered(79000L);
        vo14.setDistrictRecovered(24500L);
        exportVOList.add(vo14);

        // 第15条数据：三亚市 2025
        IncomeExpenditureExportVO vo15 = new IncomeExpenditureExportVO();
        vo15.setDistrict("三亚市");
        vo15.setYear(2025); // int类型
        vo15.setCityAllocated(810000L);
        vo15.setDistrictAllocated(455000L);
        vo15.setOtherFunds(255000L);
        vo15.setTotalFunds(1520000L);
        vo15.setPurchaseMaintain(225000L);
        vo15.setPurchaseEquipment(325000L);
        vo15.setDiseasePrevention(132000L);
        vo15.setExpertTraining(205000L);
        vo15.setThirdPartyService(405000L);
        vo15.setOtherPayment(95000L);
        vo15.setTotalPayment(1387000L);
        vo15.setCityRecovered(81000L);
        vo15.setDistrictRecovered(25500L);
        exportVOList.add(vo15);

        // 第16条数据：琼山区 2024
        IncomeExpenditureExportVO vo16 = new IncomeExpenditureExportVO();
        vo16.setDistrict("琼山区");
        vo16.setYear(2024); // int类型
        vo16.setCityAllocated(460000L);
        vo16.setDistrictAllocated(285000L);
        vo16.setOtherFunds(175000L);
        vo16.setTotalFunds(920000L);
        vo16.setPurchaseMaintain(135000L);
        vo16.setPurchaseEquipment(195000L);
        vo16.setDiseasePrevention(72000L);
        vo16.setExpertTraining(102000L);
        vo16.setThirdPartyService(225000L);
        vo16.setOtherPayment(42000L);
        vo16.setTotalPayment(771000L);
        vo16.setCityRecovered(46000L);
        vo16.setDistrictRecovered(18500L);
        exportVOList.add(vo16);

        // 第17条数据：美兰区 2024
        IncomeExpenditureExportVO vo17 = new IncomeExpenditureExportVO();
        vo17.setDistrict("美兰区");
        vo17.setYear(2024); // int类型
        vo17.setCityAllocated(560000L);
        vo17.setDistrictAllocated(99999L);
        vo17.setOtherFunds(235000L);
        vo17.setTotalFunds(894999L);
        vo17.setPurchaseMaintain(165000L);
        vo17.setPurchaseEquipment(215000L);
        vo17.setDiseasePrevention(87000L);
        vo17.setExpertTraining(132000L);
        vo17.setThirdPartyService(285000L);
        vo17.setOtherPayment(57000L);
        vo17.setTotalPayment(941000L);
        vo17.setCityRecovered(56000L);
        vo17.setDistrictRecovered(23500L);
        exportVOList.add(vo17);

        // 第18条数据：秀英区 2025
        IncomeExpenditureExportVO vo18 = new IncomeExpenditureExportVO();
        vo18.setDistrict("秀英区");
        vo18.setYear(2025); // int类型
        vo18.setCityAllocated(2L);
        vo18.setDistrictAllocated(315000L);
        vo18.setOtherFunds(215000L);
        vo18.setTotalFunds(530002L);
        vo18.setPurchaseMaintain(165000L);
        vo18.setPurchaseEquipment(215000L);
        vo18.setDiseasePrevention(84000L);
        vo18.setExpertTraining(127000L);
        vo18.setThirdPartyService(265000L);
        vo18.setOtherPayment(57000L);
        vo18.setTotalPayment(913000L);
        vo18.setCityRecovered(53000L);
        vo18.setDistrictRecovered(21500L);
        exportVOList.add(vo18);

        // 第19条数据：龙华区 2025
        IncomeExpenditureExportVO vo19 = new IncomeExpenditureExportVO();
        vo19.setDistrict("龙华区");
        vo19.setYear(2025); // int类型
        vo19.setCityAllocated(630000L);
        vo19.setDistrictAllocated(365000L);
        vo19.setOtherFunds(265000L);
        vo19.setTotalFunds(1260000L);
        vo19.setPurchaseMaintain(195000L);
        vo19.setPurchaseEquipment(235000L);
        vo19.setDiseasePrevention(97000L);
        vo19.setExpertTraining(157000L);
        vo19.setThirdPartyService(315000L);
        vo19.setOtherPayment(67000L);
        vo19.setTotalPayment(1066000L);
        vo19.setCityRecovered(63000L);
        vo19.setDistrictRecovered(26500L);
        exportVOList.add(vo19);

        // 第20条数据：琼山区 2025
        IncomeExpenditureExportVO vo20 = new IncomeExpenditureExportVO();
        vo20.setDistrict("琼山区");
        vo20.setYear(2025); // int类型
        vo20.setCityAllocated(480000L);
        vo20.setDistrictAllocated(295000L);
        vo20.setOtherFunds(185000L);
        vo20.setTotalFunds(960000L);
        vo20.setPurchaseMaintain(145000L);
        vo20.setPurchaseEquipment(205000L);
        vo20.setDiseasePrevention(77000L);
        vo20.setExpertTraining(107000L);
        vo20.setThirdPartyService(235000L);
        vo20.setOtherPayment(47000L);
        vo20.setTotalPayment(816000L);
        vo20.setCityRecovered(48000L);
        vo20.setDistrictRecovered(19500L);
        exportVOList.add(vo20);

        // 第21条数据：美兰区 2025
        IncomeExpenditureExportVO vo21 = new IncomeExpenditureExportVO();
        vo21.setDistrict("美兰区");
        vo21.setYear(2025); // int类型
        vo21.setCityAllocated(580000L);
        vo21.setDistrictAllocated(335000L);
        vo21.setOtherFunds(245000L);
        vo21.setTotalFunds(1160000L);
        vo21.setPurchaseMaintain(175000L);
        vo21.setPurchaseEquipment(225000L);
        vo21.setDiseasePrevention(89000L);
        vo21.setExpertTraining(137000L);
        vo21.setThirdPartyService(295000L);
        vo21.setOtherPayment(62000L);
        vo21.setTotalPayment(983000L);
        vo21.setCityRecovered(58000L);
        vo21.setDistrictRecovered(24500L);
        exportVOList.add(vo21);

        // 第22条数据：乐东黎族自治县 2024
        IncomeExpenditureExportVO vo22 = new IncomeExpenditureExportVO();
        vo22.setDistrict("乐东黎族自治县");
        vo22.setYear(2024); // int类型
        vo22.setCityAllocated(490000L);
        vo22.setDistrictAllocated(295000L);
        vo22.setOtherFunds(195000L);
        vo22.setTotalFunds(980000L);
        vo22.setPurchaseMaintain(145000L);
        vo22.setPurchaseEquipment(195000L);
        vo22.setDiseasePrevention(79000L);
        vo22.setExpertTraining(119000L);
        vo22.setThirdPartyService(245000L);
        vo22.setOtherPayment(49000L);
        vo22.setTotalPayment(832000L);
        vo22.setCityRecovered(49000L);
        vo22.setDistrictRecovered(19500L);
        exportVOList.add(vo22);

        // 2. 硬编码合计数据：incomeExpenditureTotalSum（无变化）
        IncomeExpenditureTotalSum totalSum = new IncomeExpenditureTotalSum();
        totalSum.setCityAllocatedSum(11480002L);
        totalSum.setDistrictAllocatedSum(7743888L);
        totalSum.setOtherFundsSum(4555002L);
        totalSum.setTotalFundsSum(23778892L);
        totalSum.setPurchaseMaintainSum(3547005L);
        totalSum.setPurchaseEquipmentSum(4867005L);
        totalSum.setDiseasePreventionSum(1925000L);
        totalSum.setExpertTrainingSum(2893001L);
        totalSum.setThirdPartyServiceSum(6037025L);
        totalSum.setOtherPaymentSum(1260005L);
        totalSum.setTotalPaymentSum(20529041L);
        totalSum.setCityRecoveredSum(1252000L);
        totalSum.setDistrictRecoveredSum(478000L);

        // 3. 封装结果
        result.setIncomeExpenditureExportVOList(exportVOList);
        result.setIncomeExpenditureTotalSum(totalSum);

        return result;
    }

    //导出用这个数据测试
    public static IncomeExpenditureResult2 getExportResultData() {
        IncomeExpenditureResult2 result = new IncomeExpenditureResult2();
        List<IncomeExpenditureExportVO> exportVOList = new ArrayList<>();

        // 第1条数据：秀英区 2024
        IncomeExpenditureExportVO vo1 = new IncomeExpenditureExportVO();
        // 基础信息（district, year）
        vo1.setDistrict("秀英区");
        vo1.setYear(2024);
        // 经费来源（cityAllocated, districtAllocated, otherFunds, totalFunds）
        vo1.setCityAllocated(0L);
        vo1.setDistrictAllocated(3L);
        vo1.setOtherFunds(2L);
        vo1.setTotalFunds(5L);
        // 已实际完成支付（purchaseMaintain, purchaseEquipment, diseasePrevention, expertTraining, thirdPartyService, otherPayment, totalPayment）
        vo1.setPurchaseMaintain(5L);
        vo1.setPurchaseEquipment(5L);
        vo1.setDiseasePrevention(0L);
        vo1.setExpertTraining(1L);
        vo1.setThirdPartyService(25L);
        vo1.setOtherPayment(5L);
        vo1.setTotalPayment(41L);
        // 被收回资金（cityRecovered, districtRecovered）
        vo1.setCityRecovered(51000L);
        vo1.setDistrictRecovered(20500L);
        exportVOList.add(vo1);

        // 第2条数据：乐东黎族自治县 2025
        IncomeExpenditureExportVO vo2 = new IncomeExpenditureExportVO();
        // 基础信息
        vo2.setDistrict("乐东黎族自治县");
        vo2.setYear(2025);
        // 经费来源
        vo2.setCityAllocated(510000L);
        vo2.setDistrictAllocated(305000L);
        vo2.setOtherFunds(205000L);
        vo2.setTotalFunds(1020000L);
        // 已实际完成支付
        vo2.setPurchaseMaintain(155000L);
        vo2.setPurchaseEquipment(205000L);
        vo2.setDiseasePrevention(82000L);
        vo2.setExpertTraining(122000L);
        vo2.setThirdPartyService(255000L);
        vo2.setOtherPayment(51000L);
        vo2.setTotalPayment(870000L);
        // 被收回资金
        vo2.setCityRecovered(51000L);
        vo2.setDistrictRecovered(20500L);
        exportVOList.add(vo2);

        // 第3条数据：临高县 2024
        IncomeExpenditureExportVO vo3 = new IncomeExpenditureExportVO();
        // 基础信息
        vo3.setDistrict("临高县");
        vo3.setYear(2024);
        // 经费来源
        vo3.setCityAllocated(440000L);
        vo3.setDistrictAllocated(999999L);
        vo3.setOtherFunds(165000L);
        vo3.setTotalFunds(1604999L);
        // 已实际完成支付
        vo3.setPurchaseMaintain(129000L);
        vo3.setPurchaseEquipment(185000L);
        vo3.setDiseasePrevention(68000L);
        vo3.setExpertTraining(98000L);
        vo3.setThirdPartyService(215000L);
        vo3.setOtherPayment(41000L);
        vo3.setTotalPayment(736000L);
        // 被收回资金
        vo3.setCityRecovered(44000L);
        vo3.setDistrictRecovered(16500L);
        exportVOList.add(vo3);

        // 第4条数据：临高县 2025
        IncomeExpenditureExportVO vo4 = new IncomeExpenditureExportVO();
        // 基础信息
        vo4.setDistrict("临高县");
        vo4.setYear(2025);
        // 经费来源
        vo4.setCityAllocated(460000L);
        vo4.setDistrictAllocated(285000L);
        vo4.setOtherFunds(175000L);
        vo4.setTotalFunds(920000L);
        // 已实际完成支付
        vo4.setPurchaseMaintain(135000L);
        vo4.setPurchaseEquipment(195000L);
        vo4.setDiseasePrevention(72000L);
        vo4.setExpertTraining(102000L);
        vo4.setThirdPartyService(225000L);
        vo4.setOtherPayment(45000L);
        vo4.setTotalPayment(774000L);
        // 被收回资金
        vo4.setCityRecovered(46000L);
        vo4.setDistrictRecovered(17500L);
        exportVOList.add(vo4);

        // 第5条数据：陵水黎族自治县 2024
        IncomeExpenditureExportVO vo5 = new IncomeExpenditureExportVO();
        // 基础信息
        vo5.setDistrict("陵水黎族自治县");
        vo5.setYear(2024);
        // 经费来源
        vo5.setCityAllocated(540000L);
        vo5.setDistrictAllocated(315000L);
        vo5.setOtherFunds(225000L);
        vo5.setTotalFunds(1080000L);
        // 已实际完成支付
        vo5.setPurchaseMaintain(164000L);
        vo5.setPurchaseEquipment(215000L);
        vo5.setDiseasePrevention(87000L);
        vo5.setExpertTraining(127000L);
        vo5.setThirdPartyService(275000L);
        vo5.setOtherPayment(54000L);
        vo5.setTotalPayment(922000L);
        // 被收回资金
        vo5.setCityRecovered(54000L);
        vo5.setDistrictRecovered(22500L);
        exportVOList.add(vo5);

        // 第6条数据：陵水黎族自治县 2025
        IncomeExpenditureExportVO vo6 = new IncomeExpenditureExportVO();
        // 基础信息
        vo6.setDistrict("陵水黎族自治县");
        vo6.setYear(2025);
        // 经费来源
        vo6.setCityAllocated(560000L);
        vo6.setDistrictAllocated(325000L);
        vo6.setOtherFunds(235000L);
        vo6.setTotalFunds(1120000L);
        // 已实际完成支付
        vo6.setPurchaseMaintain(170000L);
        vo6.setPurchaseEquipment(225000L);
        vo6.setDiseasePrevention(89000L);
        vo6.setExpertTraining(132000L);
        vo6.setThirdPartyService(285000L);
        vo6.setOtherPayment(56000L);
        vo6.setTotalPayment(957000L);
        // 被收回资金
        vo6.setCityRecovered(56000L);
        vo6.setDistrictRecovered(23500L);
        exportVOList.add(vo6);

        // 第7条数据：琼海市 2024
        IncomeExpenditureExportVO vo7 = new IncomeExpenditureExportVO();
        // 基础信息
        vo7.setDistrict("琼海市");
        vo7.setYear(2024);
        // 经费来源
        vo7.setCityAllocated(590000L);
        vo7.setDistrictAllocated(345000L);
        vo7.setOtherFunds(245000L);
        vo7.setTotalFunds(1180000L);
        // 已实际完成支付
        vo7.setPurchaseMaintain(179000L);
        vo7.setPurchaseEquipment(245000L);
        vo7.setDiseasePrevention(97000L);
        vo7.setExpertTraining(147000L);
        vo7.setThirdPartyService(315000L);
        vo7.setOtherPayment(64000L);
        vo7.setTotalPayment(1047000L);
        // 被收回资金
        vo7.setCityRecovered(59000L);
        vo7.setDistrictRecovered(24500L);
        exportVOList.add(vo7);

        // 第8条数据：琼海市 2025
        IncomeExpenditureExportVO vo8 = new IncomeExpenditureExportVO();
        // 基础信息
        vo8.setDistrict("琼海市");
        vo8.setYear(2025);
        // 经费来源
        vo8.setCityAllocated(610000L);
        vo8.setDistrictAllocated(355000L);
        vo8.setOtherFunds(255000L);
        vo8.setTotalFunds(1220000L);
        // 已实际完成支付
        vo8.setPurchaseMaintain(185000L);
        vo8.setPurchaseEquipment(255000L);
        vo8.setDiseasePrevention(99000L);
        vo8.setExpertTraining(152000L);
        vo8.setThirdPartyService(325000L);
        vo8.setOtherPayment(66000L);
        vo8.setTotalPayment(1082000L);
        // 被收回资金
        vo8.setCityRecovered(61000L);
        vo8.setDistrictRecovered(25500L);
        exportVOList.add(vo8);

        // 第9条数据：琼中黎族苗族自治县 2024
        IncomeExpenditureExportVO vo9 = new IncomeExpenditureExportVO();
        // 基础信息
        vo9.setDistrict("琼中黎族苗族自治县");
        vo9.setYear(2024);
        // 经费来源
        vo9.setCityAllocated(470000L);
        vo9.setDistrictAllocated(285000L);
        vo9.setOtherFunds(185000L);
        vo9.setTotalFunds(940000L);
        // 已实际完成支付
        vo9.setPurchaseMaintain(132000L);
        vo9.setPurchaseEquipment(192000L);
        vo9.setDiseasePrevention(74000L);
        vo9.setExpertTraining(104000L);
        vo9.setThirdPartyService(232000L);
        vo9.setOtherPayment(44000L);
        vo9.setTotalPayment(778000L);
        // 被收回资金
        vo9.setCityRecovered(47000L);
        vo9.setDistrictRecovered(18500L);
        exportVOList.add(vo9);

        // 第10条数据：琼中黎族苗族自治县 2025
        IncomeExpenditureExportVO vo10 = new IncomeExpenditureExportVO();
        // 基础信息
        vo10.setDistrict("琼中黎族苗族自治县");
        vo10.setYear(2025);
        // 经费来源
        vo10.setCityAllocated(490000L);
        vo10.setDistrictAllocated(295000L);
        vo10.setOtherFunds(195000L);
        vo10.setTotalFunds(980000L);
        // 已实际完成支付
        vo10.setPurchaseMaintain(140000L);
        vo10.setPurchaseEquipment(200000L);
        vo10.setDiseasePrevention(78000L);
        vo10.setExpertTraining(108000L);
        vo10.setThirdPartyService(240000L);
        vo10.setOtherPayment(48000L);
        vo10.setTotalPayment(814000L);
        // 被收回资金
        vo10.setCityRecovered(49000L);
        vo10.setDistrictRecovered(19500L);
        exportVOList.add(vo10);

        // 第11条数据：三沙市 2024
        IncomeExpenditureExportVO vo11 = new IncomeExpenditureExportVO();
        // 基础信息
        vo11.setDistrict("三沙市");
        vo11.setYear(2024);
        // 经费来源
        vo11.setCityAllocated(690000L);
        vo11.setDistrictAllocated(395000L);
        vo11.setOtherFunds(195000L);
        vo11.setTotalFunds(1280000L);
        // 已实际完成支付
        vo11.setPurchaseMaintain(199000L);
        vo11.setPurchaseEquipment(295000L);
        vo11.setDiseasePrevention(119000L);
        vo11.setExpertTraining(179000L);
        vo11.setThirdPartyService(345000L);
        vo11.setOtherPayment(79000L);
        vo11.setTotalPayment(1216000L);
        // 被收回资金
        vo11.setCityRecovered(69000L);
        vo11.setDistrictRecovered(19500L);
        exportVOList.add(vo11);

        // 第12条数据：龙华区 2024
        IncomeExpenditureExportVO vo12 = new IncomeExpenditureExportVO();
        // 基础信息
        vo12.setDistrict("龙华区");
        vo12.setYear(2024);
        // 经费来源
        vo12.setCityAllocated(610000L);
        vo12.setDistrictAllocated(888888L);
        vo12.setOtherFunds(255000L);
        vo12.setTotalFunds(1753888L);
        // 已实际完成支付
        vo12.setPurchaseMaintain(185000L);
        vo12.setPurchaseEquipment(225000L);
        vo12.setDiseasePrevention(92000L);
        vo12.setExpertTraining(152000L);
        vo12.setThirdPartyService(305000L);
        vo12.setOtherPayment(62000L);
        vo12.setTotalPayment(1021000L);
        // 被收回资金
        vo12.setCityRecovered(61000L);
        vo12.setDistrictRecovered(25500L);
        exportVOList.add(vo12);

        // 第13条数据：三沙市 2025
        IncomeExpenditureExportVO vo13 = new IncomeExpenditureExportVO();
        // 基础信息
        vo13.setDistrict("三沙市");
        vo13.setYear(2025);
        // 经费来源
        vo13.setCityAllocated(710000L);
        vo13.setDistrictAllocated(405000L);
        vo13.setOtherFunds(205000L);
        vo13.setTotalFunds(1320000L);
        // 已实际完成支付
        vo13.setPurchaseMaintain(205000L);
        vo13.setPurchaseEquipment(305000L);
        vo13.setDiseasePrevention(122000L);
        vo13.setExpertTraining(185000L);
        vo13.setThirdPartyService(355000L);
        vo13.setOtherPayment(85000L);
        vo13.setTotalPayment(1257000L);
        // 被收回资金
        vo13.setCityRecovered(71000L);
        vo13.setDistrictRecovered(20500L);
        exportVOList.add(vo13);

        // 第14条数据：三亚市 2024
        IncomeExpenditureExportVO vo14 = new IncomeExpenditureExportVO();
        // 基础信息
        vo14.setDistrict("三亚市");
        vo14.setYear(2024);
        // 经费来源
        vo14.setCityAllocated(790000L);
        vo14.setDistrictAllocated(99999L);
        vo14.setOtherFunds(245000L);
        vo14.setTotalFunds(1134999L);
        // 已实际完成支付
        vo14.setPurchaseMaintain(219000L);
        vo14.setPurchaseEquipment(315000L);
        vo14.setDiseasePrevention(129000L);
        vo14.setExpertTraining(199000L);
        vo14.setThirdPartyService(395000L);
        vo14.setOtherPayment(89000L);
        vo14.setTotalPayment(1346000L);
        // 被收回资金
        vo14.setCityRecovered(79000L);
        vo14.setDistrictRecovered(24500L);
        exportVOList.add(vo14);

        // 第15条数据：三亚市 2025
        IncomeExpenditureExportVO vo15 = new IncomeExpenditureExportVO();
        // 基础信息
        vo15.setDistrict("三亚市");
        vo15.setYear(2025);
        // 经费来源
        vo15.setCityAllocated(810000L);
        vo15.setDistrictAllocated(455000L);
        vo15.setOtherFunds(255000L);
        vo15.setTotalFunds(1520000L);
        // 已实际完成支付
        vo15.setPurchaseMaintain(225000L);
        vo15.setPurchaseEquipment(325000L);
        vo15.setDiseasePrevention(132000L);
        vo15.setExpertTraining(205000L);
        vo15.setThirdPartyService(405000L);
        vo15.setOtherPayment(95000L);
        vo15.setTotalPayment(1387000L);
        // 被收回资金
        vo15.setCityRecovered(81000L);
        vo15.setDistrictRecovered(25500L);
        exportVOList.add(vo15);

        // 第16条数据：琼山区 2024
        IncomeExpenditureExportVO vo16 = new IncomeExpenditureExportVO();
        // 基础信息
        vo16.setDistrict("琼山区");
        vo16.setYear(2024);
        // 经费来源
        vo16.setCityAllocated(460000L);
        vo16.setDistrictAllocated(285000L);
        vo16.setOtherFunds(175000L);
        vo16.setTotalFunds(920000L);
        // 已实际完成支付
        vo16.setPurchaseMaintain(135000L);
        vo16.setPurchaseEquipment(195000L);
        vo16.setDiseasePrevention(72000L);
        vo16.setExpertTraining(102000L);
        vo16.setThirdPartyService(225000L);
        vo16.setOtherPayment(42000L);
        vo16.setTotalPayment(771000L);
        // 被收回资金
        vo16.setCityRecovered(46000L);
        vo16.setDistrictRecovered(18500L);
        exportVOList.add(vo16);

        // 第17条数据：美兰区 2024
        IncomeExpenditureExportVO vo17 = new IncomeExpenditureExportVO();
        // 基础信息
        vo17.setDistrict("美兰区");
        vo17.setYear(2024);
        // 经费来源
        vo17.setCityAllocated(560000L);
        vo17.setDistrictAllocated(99999L);
        vo17.setOtherFunds(235000L);
        vo17.setTotalFunds(894999L);
        // 已实际完成支付
        vo17.setPurchaseMaintain(165000L);
        vo17.setPurchaseEquipment(215000L);
        vo17.setDiseasePrevention(87000L);
        vo17.setExpertTraining(132000L);
        vo17.setThirdPartyService(285000L);
        vo17.setOtherPayment(57000L);
        vo17.setTotalPayment(941000L);
        // 被收回资金
        vo17.setCityRecovered(56000L);
        vo17.setDistrictRecovered(23500L);
        exportVOList.add(vo17);

        // 第18条数据：秀英区 2025
        IncomeExpenditureExportVO vo18 = new IncomeExpenditureExportVO();
        // 基础信息
        vo18.setDistrict("秀英区");
        vo18.setYear(2025);
        // 经费来源
        vo18.setCityAllocated(2L);
        vo18.setDistrictAllocated(315000L);
        vo18.setOtherFunds(215000L);
        vo18.setTotalFunds(530002L);
        // 已实际完成支付
        vo18.setPurchaseMaintain(165000L);
        vo18.setPurchaseEquipment(215000L);
        vo18.setDiseasePrevention(84000L);
        vo18.setExpertTraining(127000L);
        vo18.setThirdPartyService(265000L);
        vo18.setOtherPayment(57000L);
        vo18.setTotalPayment(913000L);
        // 被收回资金
        vo18.setCityRecovered(53000L);
        vo18.setDistrictRecovered(21500L);
        exportVOList.add(vo18);

        // 第19条数据：龙华区 2025
        IncomeExpenditureExportVO vo19 = new IncomeExpenditureExportVO();
        // 基础信息
        vo19.setDistrict("龙华区");
        vo19.setYear(2025);
        // 经费来源
        vo19.setCityAllocated(630000L);
        vo19.setDistrictAllocated(365000L);
        vo19.setOtherFunds(265000L);
        vo19.setTotalFunds(1260000L);
        // 已实际完成支付
        vo19.setPurchaseMaintain(195000L);
        vo19.setPurchaseEquipment(235000L);
        vo19.setDiseasePrevention(97000L);
        vo19.setExpertTraining(157000L);
        vo19.setThirdPartyService(315000L);
        vo19.setOtherPayment(67000L);
        vo19.setTotalPayment(1066000L);
        // 被收回资金
        vo19.setCityRecovered(63000L);
        vo19.setDistrictRecovered(26500L);
        exportVOList.add(vo19);

        // 第20条数据：琼山区 2025
        IncomeExpenditureExportVO vo20 = new IncomeExpenditureExportVO();
        // 基础信息
        vo20.setDistrict("琼山区");
        vo20.setYear(2025);
        // 经费来源
        vo20.setCityAllocated(480000L);
        vo20.setDistrictAllocated(295000L);
        vo20.setOtherFunds(185000L);
        vo20.setTotalFunds(960000L);
        // 已实际完成支付
        vo20.setPurchaseMaintain(145000L);
        vo20.setPurchaseEquipment(205000L);
        vo20.setDiseasePrevention(77000L);
        vo20.setExpertTraining(107000L);
        vo20.setThirdPartyService(235000L);
        vo20.setOtherPayment(47000L);
        vo20.setTotalPayment(816000L);
        // 被收回资金
        vo20.setCityRecovered(48000L);
        vo20.setDistrictRecovered(19500L);
        exportVOList.add(vo20);

        // 第21条数据：美兰区 2025
        IncomeExpenditureExportVO vo21 = new IncomeExpenditureExportVO();
        // 基础信息
        vo21.setDistrict("美兰区");
        vo21.setYear(2025);
        // 经费来源
        vo21.setCityAllocated(580000L);
        vo21.setDistrictAllocated(335000L);
        vo21.setOtherFunds(245000L);
        vo21.setTotalFunds(1160000L);
        // 已实际完成支付
        vo21.setPurchaseMaintain(175000L);
        vo21.setPurchaseEquipment(225000L);
        vo21.setDiseasePrevention(89000L);
        vo21.setExpertTraining(137000L);
        vo21.setThirdPartyService(295000L);
        vo21.setOtherPayment(62000L);
        vo21.setTotalPayment(983000L);
        // 被收回资金
        vo21.setCityRecovered(58000L);
        vo21.setDistrictRecovered(24500L);
        exportVOList.add(vo21);

        // 第22条数据：乐东黎族自治县 2024
        IncomeExpenditureExportVO vo22 = new IncomeExpenditureExportVO();
        // 基础信息
        vo22.setDistrict("乐东黎族自治县");
        vo22.setYear(2024);
        // 经费来源
        vo22.setCityAllocated(490000L);
        vo22.setDistrictAllocated(295000L);
        vo22.setOtherFunds(195000L);
        vo22.setTotalFunds(980000L);
        // 已实际完成支付
        vo22.setPurchaseMaintain(145000L);
        vo22.setPurchaseEquipment(195000L);
        vo22.setDiseasePrevention(79000L);
        vo22.setExpertTraining(119000L);
        vo22.setThirdPartyService(245000L);
        vo22.setOtherPayment(49000L);
        vo22.setTotalPayment(832000L);
        // 被收回资金
        vo22.setCityRecovered(49000L);
        vo22.setDistrictRecovered(19500L);
        exportVOList.add(vo22);

        // 2. 硬编码合计数据：incomeExpenditureTotalSum（无变化）
        IncomeExpenditureTotalSum totalSum = new IncomeExpenditureTotalSum();
        totalSum.setCityAllocatedSum(11480002L);
        totalSum.setDistrictAllocatedSum(7743888L);
        totalSum.setOtherFundsSum(4555002L);
        totalSum.setTotalFundsSum(23778892L);
        totalSum.setPurchaseMaintainSum(3547005L);
        totalSum.setPurchaseEquipmentSum(4867005L);
        totalSum.setDiseasePreventionSum(1925000L);
        totalSum.setExpertTrainingSum(2893001L);
        totalSum.setThirdPartyServiceSum(6037025L);
        totalSum.setOtherPaymentSum(1260005L);
        totalSum.setTotalPaymentSum(20529041L);
        totalSum.setCityRecoveredSum(1252000L);
        totalSum.setDistrictRecoveredSum(478000L);

        // 3. 封装结果
        result.setIncomeExpenditureExportVOList(exportVOList);
        result.setIncomeExpenditureTotalSum(totalSum);

        return result;
    }

    //导出用这个数据测试
    public static IncomeExpenditureResult2 getExportData() {
        IncomeExpenditureResult2 result = new IncomeExpenditureResult2();
        List<IncomeExpenditureExportVO> exportVOList = new ArrayList<>();

            // 第1条数据：秀英区 2024（JSON中id=1）
            IncomeExpenditureExportVO vo1 = new IncomeExpenditureExportVO();
            vo1.setDistrict("秀英区");
            vo1.setYear(2024);
            vo1.setCityAllocated(0L);
            vo1.setDistrictAllocated(3L);
            vo1.setOtherFunds(2L);
            vo1.setTotalFunds(5L);
            vo1.setPurchaseMaintain(5L);
            vo1.setPurchaseEquipment(5L);
            vo1.setDiseasePrevention(0L);
            vo1.setExpertTraining(1L);
            vo1.setThirdPartyService(25L);
            vo1.setOtherPayment(5L);
            vo1.setTotalPayment(41L);
            vo1.setCityRecovered(51000L);
            vo1.setDistrictRecovered(20500L);
            exportVOList.add(vo1);

            // 第2条数据：秀英区 2025（JSON中id=5，与第1条同地区不同年份）
            IncomeExpenditureExportVO vo2 = new IncomeExpenditureExportVO();
            vo2.setDistrict("秀英区");
            vo2.setYear(2025);
            vo2.setCityAllocated(2L);
            vo2.setDistrictAllocated(315000L);
            vo2.setOtherFunds(215000L);
            vo2.setTotalFunds(530002L);
            vo2.setPurchaseMaintain(165000L);
            vo2.setPurchaseEquipment(215000L);
            vo2.setDiseasePrevention(84000L);
            vo2.setExpertTraining(127000L);
            vo2.setThirdPartyService(265000L);
            vo2.setOtherPayment(57000L);
            vo2.setTotalPayment(913000L);
            vo2.setCityRecovered(53000L);
            vo2.setDistrictRecovered(21500L);
            exportVOList.add(vo2);

            // 第3条数据：龙华区 2024（JSON中id=2）
            IncomeExpenditureExportVO vo3 = new IncomeExpenditureExportVO();
            vo3.setDistrict("龙华区");
            vo3.setYear(2024);
            vo3.setCityAllocated(610000L);
            vo3.setDistrictAllocated(888888L);
            vo3.setOtherFunds(255000L);
            vo3.setTotalFunds(1753888L);
            vo3.setPurchaseMaintain(185000L);
            vo3.setPurchaseEquipment(225000L);
            vo3.setDiseasePrevention(92000L);
            vo3.setExpertTraining(152000L);
            vo3.setThirdPartyService(305000L);
            vo3.setOtherPayment(62000L);
            vo3.setTotalPayment(1021000L);
            vo3.setCityRecovered(61000L);
            vo3.setDistrictRecovered(25500L);
            exportVOList.add(vo3);

            // 第4条数据：龙华区 2025（JSON中id=6）
            IncomeExpenditureExportVO vo4 = new IncomeExpenditureExportVO();
            vo4.setDistrict("龙华区");
            vo4.setYear(2025);
            vo4.setCityAllocated(630000L);
            vo4.setDistrictAllocated(365000L);
            vo4.setOtherFunds(265000L);
            vo4.setTotalFunds(1260000L);
            vo4.setPurchaseMaintain(195000L);
            vo4.setPurchaseEquipment(235000L);
            vo4.setDiseasePrevention(97000L);
            vo4.setExpertTraining(157000L);
            vo4.setThirdPartyService(315000L);
            vo4.setOtherPayment(67000L);
            vo4.setTotalPayment(1066000L);
            vo4.setCityRecovered(63000L);
            vo4.setDistrictRecovered(26500L);
            exportVOList.add(vo4);

            // 第5条数据：琼山区 2024（JSON中id=3）
            IncomeExpenditureExportVO vo5 = new IncomeExpenditureExportVO();
            vo5.setDistrict("琼山区");
            vo5.setYear(2024);
            vo5.setCityAllocated(460000L);
            vo5.setDistrictAllocated(285000L);
            vo5.setOtherFunds(175000L);
            vo5.setTotalFunds(920000L);
            vo5.setPurchaseMaintain(135000L);
            vo5.setPurchaseEquipment(195000L);
            vo5.setDiseasePrevention(72000L);
            vo5.setExpertTraining(102000L);
            vo5.setThirdPartyService(225000L);
            vo5.setOtherPayment(42000L);
            vo5.setTotalPayment(771000L);
            vo5.setCityRecovered(46000L);
            vo5.setDistrictRecovered(18500L);
            exportVOList.add(vo5);

            // 第6条数据：琼山区 2025（JSON中id=7）
            IncomeExpenditureExportVO vo6 = new IncomeExpenditureExportVO();
            vo6.setDistrict("琼山区");
            vo6.setYear(2025);
            vo6.setCityAllocated(480000L);
            vo6.setDistrictAllocated(295000L);
            vo6.setOtherFunds(185000L);
            vo6.setTotalFunds(960000L);
            vo6.setPurchaseMaintain(145000L);
            vo6.setPurchaseEquipment(205000L);
            vo6.setDiseasePrevention(77000L);
            vo6.setExpertTraining(107000L);
            vo6.setThirdPartyService(235000L);
            vo6.setOtherPayment(47000L);
            vo6.setTotalPayment(816000L);
            vo6.setCityRecovered(48000L);
            vo6.setDistrictRecovered(19500L);
            exportVOList.add(vo6);

            // 第7条数据：美兰区 2024（JSON中id=4）
            IncomeExpenditureExportVO vo7 = new IncomeExpenditureExportVO();
            vo7.setDistrict("美兰区");
            vo7.setYear(2024);
            vo7.setCityAllocated(560000L);
            vo7.setDistrictAllocated(99999L);
            vo7.setOtherFunds(235000L);
            vo7.setTotalFunds(894999L);
            vo7.setPurchaseMaintain(165000L);
            vo7.setPurchaseEquipment(215000L);
            vo7.setDiseasePrevention(87000L);
            vo7.setExpertTraining(132000L);
            vo7.setThirdPartyService(285000L);
            vo7.setOtherPayment(57000L);
            vo7.setTotalPayment(941000L);
            vo7.setCityRecovered(56000L);
            vo7.setDistrictRecovered(23500L);
            exportVOList.add(vo7);

            // 第8条数据：美兰区 2025（JSON中id=8）
            IncomeExpenditureExportVO vo8 = new IncomeExpenditureExportVO();
            vo8.setDistrict("美兰区");
            vo8.setYear(2025);
            vo8.setCityAllocated(580000L);
            vo8.setDistrictAllocated(335000L);
            vo8.setOtherFunds(245000L);
            vo8.setTotalFunds(1160000L);
            vo8.setPurchaseMaintain(175000L);
            vo8.setPurchaseEquipment(225000L);
            vo8.setDiseasePrevention(89000L);
            vo8.setExpertTraining(137000L);
            vo8.setThirdPartyService(295000L);
            vo8.setOtherPayment(62000L);
            vo8.setTotalPayment(983000L);
            vo8.setCityRecovered(58000L);
            vo8.setDistrictRecovered(24500L);
            exportVOList.add(vo8);

            // 第9条数据：三亚市 2024（JSON中id=21）
            IncomeExpenditureExportVO vo9 = new IncomeExpenditureExportVO();
            vo9.setDistrict("三亚市");
            vo9.setYear(2024);
            vo9.setCityAllocated(790000L);
            vo9.setDistrictAllocated(99999L);
            vo9.setOtherFunds(245000L);
            vo9.setTotalFunds(1134999L);
            vo9.setPurchaseMaintain(219000L);
            vo9.setPurchaseEquipment(315000L);
            vo9.setDiseasePrevention(129000L);
            vo9.setExpertTraining(199000L);
            vo9.setThirdPartyService(395000L);
            vo9.setOtherPayment(89000L);
            vo9.setTotalPayment(1346000L);
            vo9.setCityRecovered(79000L);
            vo9.setDistrictRecovered(24500L);
            exportVOList.add(vo9);

            // 第10条数据：三亚市 2025（JSON中id=22）
            IncomeExpenditureExportVO vo10 = new IncomeExpenditureExportVO();
            vo10.setDistrict("三亚市");
            vo10.setYear(2025);
            vo10.setCityAllocated(810000L);
            vo10.setDistrictAllocated(455000L);
            vo10.setOtherFunds(255000L);
            vo10.setTotalFunds(1520000L);
            vo10.setPurchaseMaintain(225000L);
            vo10.setPurchaseEquipment(325000L);
            vo10.setDiseasePrevention(132000L);
            vo10.setExpertTraining(205000L);
            vo10.setThirdPartyService(405000L);
            vo10.setOtherPayment(95000L);
            vo10.setTotalPayment(1387000L);
            vo10.setCityRecovered(81000L);
            vo10.setDistrictRecovered(25500L);
            exportVOList.add(vo10);

            // 第11条数据：三沙市 2024（JSON中id=19）
            IncomeExpenditureExportVO vo11 = new IncomeExpenditureExportVO();
            vo11.setDistrict("三沙市");
            vo11.setYear(2024);
            vo11.setCityAllocated(690000L);
            vo11.setDistrictAllocated(395000L);
            vo11.setOtherFunds(195000L);
            vo11.setTotalFunds(1280000L);
            vo11.setPurchaseMaintain(199000L);
            vo11.setPurchaseEquipment(295000L);
            vo11.setDiseasePrevention(119000L);
            vo11.setExpertTraining(179000L);
            vo11.setThirdPartyService(345000L);
            vo11.setOtherPayment(79000L);
            vo11.setTotalPayment(1216000L);
            vo11.setCityRecovered(69000L);
            vo11.setDistrictRecovered(19500L);
            exportVOList.add(vo11);

            // 第12条数据：三沙市 2025（JSON中id=20）
            IncomeExpenditureExportVO vo12 = new IncomeExpenditureExportVO();
            vo12.setDistrict("三沙市");
            vo12.setYear(2025);
            vo12.setCityAllocated(710000L);
            vo12.setDistrictAllocated(405000L);
            vo12.setOtherFunds(205000L);
            vo12.setTotalFunds(1320000L);
            vo12.setPurchaseMaintain(205000L);
            vo12.setPurchaseEquipment(305000L);
            vo12.setDiseasePrevention(122000L);
            vo12.setExpertTraining(185000L);
            vo12.setThirdPartyService(355000L);
            vo12.setOtherPayment(85000L);
            vo12.setTotalPayment(1257000L);
            vo12.setCityRecovered(71000L);
            vo12.setDistrictRecovered(20500L);
            exportVOList.add(vo12);

            // 第13条数据：琼海市 2024（JSON中id=15）
            IncomeExpenditureExportVO vo13 = new IncomeExpenditureExportVO();
            vo13.setDistrict("琼海市");
            vo13.setYear(2024);
            vo13.setCityAllocated(590000L);
            vo13.setDistrictAllocated(345000L);
            vo13.setOtherFunds(245000L);
            vo13.setTotalFunds(1180000L);
            vo13.setPurchaseMaintain(179000L);
            vo13.setPurchaseEquipment(245000L);
            vo13.setDiseasePrevention(97000L);
            vo13.setExpertTraining(147000L);
            vo13.setThirdPartyService(315000L);
            vo13.setOtherPayment(64000L);
            vo13.setTotalPayment(1047000L);
            vo13.setCityRecovered(59000L);
            vo13.setDistrictRecovered(24500L);
            exportVOList.add(vo13);

            // 第14条数据：琼海市 2025（JSON中id=16）
            IncomeExpenditureExportVO vo14 = new IncomeExpenditureExportVO();
            vo14.setDistrict("琼海市");
            vo14.setYear(2025);
            vo14.setCityAllocated(610000L);
            vo14.setDistrictAllocated(355000L);
            vo14.setOtherFunds(255000L);
            vo14.setTotalFunds(1220000L);
            vo14.setPurchaseMaintain(185000L);
            vo14.setPurchaseEquipment(255000L);
            vo14.setDiseasePrevention(99000L);
            vo14.setExpertTraining(152000L);
            vo14.setThirdPartyService(325000L);
            vo14.setOtherPayment(66000L);
            vo14.setTotalPayment(1082000L);
            vo14.setCityRecovered(61000L);
            vo14.setDistrictRecovered(25500L);
            exportVOList.add(vo14);

            // 第15条数据：临高县 2024（JSON中id=11）
            IncomeExpenditureExportVO vo15 = new IncomeExpenditureExportVO();
            vo15.setDistrict("临高县");
            vo15.setYear(2024);
            vo15.setCityAllocated(440000L);
            vo15.setDistrictAllocated(999999L);
            vo15.setOtherFunds(165000L);
            vo15.setTotalFunds(1604999L);
            vo15.setPurchaseMaintain(129000L);
            vo15.setPurchaseEquipment(185000L);
            vo15.setDiseasePrevention(68000L);
            vo15.setExpertTraining(98000L);
            vo15.setThirdPartyService(215000L);
            vo15.setOtherPayment(41000L);
            vo15.setTotalPayment(736000L);
            vo15.setCityRecovered(44000L);
            vo15.setDistrictRecovered(16500L);
            exportVOList.add(vo15);

            // 第16条数据：临高县 2025（JSON中id=12）
            IncomeExpenditureExportVO vo16 = new IncomeExpenditureExportVO();
            vo16.setDistrict("临高县");
            vo16.setYear(2025);
            vo16.setCityAllocated(460000L);
            vo16.setDistrictAllocated(285000L);
            vo16.setOtherFunds(175000L);
            vo16.setTotalFunds(920000L);
            vo16.setPurchaseMaintain(135000L);
            vo16.setPurchaseEquipment(195000L);
            vo16.setDiseasePrevention(72000L);
            vo16.setExpertTraining(102000L);
            vo16.setThirdPartyService(225000L);
            vo16.setOtherPayment(45000L);
            vo16.setTotalPayment(774000L);
            vo16.setCityRecovered(46000L);
            vo16.setDistrictRecovered(17500L);
            exportVOList.add(vo16);

            // 第17条数据：乐东黎族自治县 2024（JSON中id=9）
            IncomeExpenditureExportVO vo17 = new IncomeExpenditureExportVO();
            vo17.setDistrict("乐东黎族自治县");
            vo17.setYear(2024);
            vo17.setCityAllocated(490000L);
            vo17.setDistrictAllocated(295000L);
            vo17.setOtherFunds(195000L);
            vo17.setTotalFunds(980000L);
            vo17.setPurchaseMaintain(145000L);
            vo17.setPurchaseEquipment(195000L);
            vo17.setDiseasePrevention(79000L);
            vo17.setExpertTraining(119000L);
            vo17.setThirdPartyService(245000L);
            vo17.setOtherPayment(49000L);
            vo17.setTotalPayment(832000L);
            vo17.setCityRecovered(49000L);
            vo17.setDistrictRecovered(19500L);
            exportVOList.add(vo17);

            // 第18条数据：乐东黎族自治县 2025（JSON中id=10）
            IncomeExpenditureExportVO vo18 = new IncomeExpenditureExportVO();
            vo18.setDistrict("乐东黎族自治县");
            vo18.setYear(2025);
            vo18.setCityAllocated(510000L);
            vo18.setDistrictAllocated(305000L);
            vo18.setOtherFunds(205000L);
            vo18.setTotalFunds(1020000L);
            vo18.setPurchaseMaintain(155000L);
            vo18.setPurchaseEquipment(205000L);
            vo18.setDiseasePrevention(82000L);
            vo18.setExpertTraining(122000L);
            vo18.setThirdPartyService(255000L);
            vo18.setOtherPayment(51000L);
            vo18.setTotalPayment(870000L);
            vo18.setCityRecovered(51000L);
            vo18.setDistrictRecovered(20500L);
            exportVOList.add(vo18);

            // 第19条数据：陵水黎族自治县 2024（JSON中id=13）
            IncomeExpenditureExportVO vo19 = new IncomeExpenditureExportVO();
            vo19.setDistrict("陵水黎族自治县");
            vo19.setYear(2024);
            vo19.setCityAllocated(540000L);
            vo19.setDistrictAllocated(315000L);
            vo19.setOtherFunds(225000L);
            vo19.setTotalFunds(1080000L);
            vo19.setPurchaseMaintain(164000L);
            vo19.setPurchaseEquipment(215000L);
            vo19.setDiseasePrevention(87000L);
            vo19.setExpertTraining(127000L);
            vo19.setThirdPartyService(275000L);
            vo19.setOtherPayment(54000L);
            vo19.setTotalPayment(922000L);
            vo19.setCityRecovered(54000L);
            vo19.setDistrictRecovered(22500L);
            exportVOList.add(vo19);

            // 第20条数据：陵水黎族自治县 2025（JSON中id=14）
            IncomeExpenditureExportVO vo20 = new IncomeExpenditureExportVO();
            vo20.setDistrict("陵水黎族自治县");
            vo20.setYear(2025);
            vo20.setCityAllocated(560000L);
            vo20.setDistrictAllocated(325000L);
            vo20.setOtherFunds(235000L);
            vo20.setTotalFunds(1120000L);
            vo20.setPurchaseMaintain(170000L);
            vo20.setPurchaseEquipment(225000L);
            vo20.setDiseasePrevention(89000L);
            vo20.setExpertTraining(132000L);
            vo20.setThirdPartyService(285000L);
            vo20.setOtherPayment(56000L);
            vo20.setTotalPayment(957000L);
            vo20.setCityRecovered(56000L);
            vo20.setDistrictRecovered(23500L);
            exportVOList.add(vo20);

            // 第21条数据：琼中黎族苗族自治县 2024（JSON中id=17）
            IncomeExpenditureExportVO vo21 = new IncomeExpenditureExportVO();
            vo21.setDistrict("琼中黎族苗族自治县");
            vo21.setYear(2024);
            vo21.setCityAllocated(470000L);
            vo21.setDistrictAllocated(285000L);
            vo21.setOtherFunds(185000L);
            vo21.setTotalFunds(940000L);
            vo21.setPurchaseMaintain(132000L);
            vo21.setPurchaseEquipment(192000L);
            vo21.setDiseasePrevention(74000L);
            vo21.setExpertTraining(104000L);
            vo21.setThirdPartyService(232000L);
            vo21.setOtherPayment(44000L);
            vo21.setTotalPayment(778000L);
            vo21.setCityRecovered(47000L);
            vo21.setDistrictRecovered(18500L);
            exportVOList.add(vo21);

            // 第22条数据：琼中黎族苗族自治县 2025（JSON中id=18）
            IncomeExpenditureExportVO vo22 = new IncomeExpenditureExportVO();
            vo22.setDistrict("琼中黎族苗族自治县");
            vo22.setYear(2025);
            vo22.setCityAllocated(490000L);
            vo22.setDistrictAllocated(295000L);
            vo22.setOtherFunds(195000L);
            vo22.setTotalFunds(980000L);
            vo22.setPurchaseMaintain(140000L);
            vo22.setPurchaseEquipment(200000L);
            vo22.setDiseasePrevention(78000L);
            vo22.setExpertTraining(108000L);
            vo22.setThirdPartyService(240000L);
            vo22.setOtherPayment(48000L);
            vo22.setTotalPayment(814000L);
            vo22.setCityRecovered(49000L);
            vo22.setDistrictRecovered(19500L);
            exportVOList.add(vo22);

        // 2. 硬编码合计数据：incomeExpenditureTotalSum（与JSON中合计数据一致）
        IncomeExpenditureTotalSum totalSum = new IncomeExpenditureTotalSum();
        totalSum.setCityAllocatedSum(11480002L);
        totalSum.setDistrictAllocatedSum(7743888L);
        totalSum.setOtherFundsSum(4555002L);
        totalSum.setTotalFundsSum(23778892L);
        totalSum.setPurchaseMaintainSum(3547005L);
        totalSum.setPurchaseEquipmentSum(4867005L);
        totalSum.setDiseasePreventionSum(1925000L);
        totalSum.setExpertTrainingSum(2893001L);
        totalSum.setThirdPartyServiceSum(6037025L);
        totalSum.setOtherPaymentSum(1260005L);
        totalSum.setTotalPaymentSum(20529041L);
        totalSum.setCityRecoveredSum(1252000L);
        totalSum.setDistrictRecoveredSum(478000L);

        // 3. 封装结果
        result.setIncomeExpenditureExportVOList(exportVOList);
        result.setIncomeExpenditureTotalSum(totalSum);

        return result;
    }

    public static List<String> commCitys = Arrays.asList("460108", "460107", "460206", "460106", "460205", "460105", "460204", "460100", "460203", "460400", "460323", "460202", "460300", "460322", "460200", "460321", "469028", "469006", "469027", "469005", "469026", "469025", "469024", "469002", "469001", "469023", "469022", "469021", "46902400000", "46902100000", "469007", "469029", "46900700000", "469030");

    // 日期格式化器（匹配@JsonFormat的pattern和时区）
    private static final SimpleDateFormat DATE_FORMAT = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    static {
        DATE_FORMAT.setTimeZone(java.util.TimeZone.getTimeZone("GMT+8"));
    }

    /**
     * 获取硬编码的收支测试数据
     * @return IncomeExpenditureResult 包含明细列表和合计数据
     */
    public static IncomeExpenditureResult getTestIncomeExpenditureData() {
        IncomeExpenditureResult result = new IncomeExpenditureResult();

        // 1. 构建明细列表：incomeExpenditureDetailVOList（24条数据）
        List<IncomeExpenditureDetailVO> detailVOList = new ArrayList<>();
        try {
            // 第1条：秀英区 2024
            detailVOList.add(buildDetailVO(
                    "1", "460105", "秀英区", 2024,
                    0L, 3L, 2L, 5L,
                    5L, 5L, 0L, 1L, 25L, 5L, 41L,
                    51000L, 20500L,
                    "admin", parseDate("2024-05-10 10:20:30"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第2条：秀英区 2025
            detailVOList.add(buildDetailVO(
                    "5", "460105", "秀英区", 2025,
                    2L, 315000L, 215000L, 530002L,
                    165000L, 215000L, 84000L, 127000L, 265000L, 57000L, 913000L,
                    53000L, 21500L,
                    "admin", parseDate("2025-03-08 11:10:22"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第3条：龙华区 2024
            detailVOList.add(buildDetailVO(
                    "2", "460106", "龙华区", 2024,
                    610000L, 888888L, 255000L, 1753888L,
                    185000L, 225000L, 92000L, 152000L, 305000L, 62000L, 1021000L,
                    61000L, 25500L,
                    "admin", parseDate("2024-07-15 14:45:12"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第4条：龙华区 2025
            detailVOList.add(buildDetailVO(
                    "6", "460106", "龙华区", 2025,
                    630000L, 365000L, 265000L, 1260000L,
                    195000L, 235000L, 97000L, 157000L, 315000L, 67000L, 1066000L,
                    63000L, 26500L,
                    "admin", parseDate("2025-06-12 15:25:18"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第5条：琼山区 2024
            detailVOList.add(buildDetailVO(
                    "3", "460107", "琼山区", 2024,
                    460000L, 285000L, 175000L, 920000L,
                    135000L, 195000L, 72000L, 102000L, 225000L, 42000L, 771000L,
                    46000L, 18500L,
                    "admin", parseDate("2024-09-05 09:15:00"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第6条：琼山区 2025
            detailVOList.add(buildDetailVO(
                    "7", "460107", "琼山区", 2025,
                    480000L, 295000L, 185000L, 960000L,
                    145000L, 205000L, 77000L, 107000L, 235000L, 47000L, 816000L,
                    48000L, 19500L,
                    "admin", parseDate("2025-08-03 08:40:05"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第7条：美兰区 2024
            detailVOList.add(buildDetailVO(
                    "4", "460108", "美兰区", 2024,
                    560000L, 99999L, 235000L, 894999L,
                    165000L, 215000L, 87000L, 132000L, 285000L, 57000L, 941000L,
                    56000L, 23500L,
                    "admin", parseDate("2024-11-20 16:30:45"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第8条：美兰区 2025
            detailVOList.add(buildDetailVO(
                    "8", "460108", "美兰区", 2025,
                    580000L, 335000L, 245000L, 1160000L,
                    175000L, 225000L, 89000L, 137000L, 295000L, 62000L, 983000L,
                    58000L, 24500L,
                    "admin", parseDate("2025-10-22 09:00:00"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第9条：三亚市 2024
            detailVOList.add(buildDetailVO(
                    "21", "460200", "三亚市", 2024,
                    790000L, 99999L, 245000L, 1134999L,
                    219000L, 315000L, 129000L, 199000L, 395000L, 89000L, 1346000L,
                    79000L, 24500L,
                    "admin", parseDate("2024-05-20 10:45:10"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第10条：三亚市 2025
            detailVOList.add(buildDetailVO(
                    "22", "460200", "三亚市", 2025,
                    810000L, 455000L, 255000L, 1520000L,
                    225000L, 325000L, 132000L, 205000L, 405000L, 95000L, 1387000L,
                    81000L, 25500L,
                    "admin", parseDate("2025-05-25 11:30:25"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第11条：三沙市 2024
            detailVOList.add(buildDetailVO(
                    "19", "460300", "三沙市", 2024,
                    690000L, 395000L, 195000L, 1280000L,
                    199000L, 295000L, 119000L, 179000L, 345000L, 79000L, 1216000L,
                    69000L, 19500L,
                    "admin", parseDate("2024-03-05 14:15:35"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第12条：三沙市 2025
            detailVOList.add(buildDetailVO(
                    "20", "460300", "三沙市", 2025,
                    710000L, 405000L, 205000L, 1320000L,
                    205000L, 305000L, 122000L, 185000L, 355000L, 85000L, 1257000L,
                    71000L, 20500L,
                    "admin", parseDate("2025-03-10 15:20:40"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第13条：琼海市 2024
            detailVOList.add(buildDetailVO(
                    "15", "469002", "琼海市", 2024,
                    590000L, 345000L, 245000L, 1180000L,
                    179000L, 245000L, 97000L, 147000L, 315000L, 64000L, 1047000L,
                    59000L, 24500L,
                    "admin", parseDate("2024-10-22 14:25:15"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第14条：琼海市 2025
            detailVOList.add(buildDetailVO(
                    "16", "469002", "琼海市", 2025,
                    610000L, 355000L, 255000L, 1220000L,
                    185000L, 255000L, 99000L, 152000L, 325000L, 66000L, 1082000L,
                    61000L, 25500L,
                    "admin", parseDate("2025-10-28 15:10:25"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第15条：临高县 2024
            detailVOList.add(buildDetailVO(
                    "11", "469024", "临高县", 2024,
                    440000L, 999999L, 165000L, 1604999L,
                    129000L, 185000L, 68000L, 98000L, 215000L, 41000L, 736000L,
                    44000L, 16500L,
                    "admin", parseDate("2024-06-30 15:40:10"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第16条：临高县 2025
            detailVOList.add(buildDetailVO(
                    "12", "469024", "临高县", 2025,
                    460000L, 285000L, 175000L, 920000L,
                    135000L, 195000L, 72000L, 102000L, 225000L, 45000L, 774000L,
                    46000L, 17500L,
                    "admin", parseDate("2025-07-05 16:20:45"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第17条：乐东黎族自治县 2024
            detailVOList.add(buildDetailVO(
                    "9", "469027", "乐东黎族自治县", 2024,
                    490000L, 295000L, 195000L, 980000L,
                    145000L, 195000L, 79000L, 119000L, 245000L, 49000L, 832000L,
                    49000L, 19500L,
                    "admin", parseDate("2024-04-18 10:30:20"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第18条：乐东黎族自治县 2025
            detailVOList.add(buildDetailVO(
                    "10", "469027", "乐东黎族自治县", 2025,
                    510000L, 305000L, 205000L, 1020000L,
                    155000L, 205000L, 82000L, 122000L, 255000L, 51000L, 870000L,
                    51000L, 20500L,
                    "admin", parseDate("2025-04-25 11:15:35"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第19条：陵水黎族自治县 2024
            detailVOList.add(buildDetailVO(
                    "13", "469028", "陵水黎族自治县", 2024,
                    540000L, 315000L, 225000L, 1080000L,
                    164000L, 215000L, 87000L, 127000L, 275000L, 54000L, 922000L,
                    54000L, 22500L,
                    "admin", parseDate("2024-08-15 09:10:50"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第20条：陵水黎族自治县 2025
            detailVOList.add(buildDetailVO(
                    "14", "469028", "陵水黎族自治县", 2025,
                    560000L, 325000L, 235000L, 1120000L,
                    170000L, 225000L, 89000L, 132000L, 285000L, 56000L, 957000L,
                    56000L, 23500L,
                    "admin", parseDate("2025-08-20 10:05:30"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第21条：琼中黎族苗族自治县 2024
            detailVOList.add(buildDetailVO(
                    "17", "469030", "琼中黎族苗族自治县", 2024,
                    470000L, 285000L, 185000L, 940000L,
                    132000L, 192000L, 74000L, 104000L, 232000L, 44000L, 778000L,
                    47000L, 18500L,
                    "admin", parseDate("2024-12-10 11:50:20"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

            // 第22条：琼中黎族苗族自治县 2025
            detailVOList.add(buildDetailVO(
                    "18", "469030", "琼中黎族苗族自治县", 2025,
                    490000L, 295000L, 195000L, 980000L,
                    140000L, 200000L, 78000L, 108000L, 240000L, 48000L, 814000L,
                    49000L, 19500L,
                    "admin", parseDate("2025-02-15 09:30:10"),
                    "1", parseDate("2025-10-27 15:30:44")
            ));

        } catch (ParseException e) {
            throw new RuntimeException("日期格式化失败：" + e.getMessage());
        }

        // 2. 构建合计数据：incomeExpenditureTotalSum
        IncomeExpenditureTotalSum totalSum = new IncomeExpenditureTotalSum();
        totalSum.setCityAllocatedSum(11480002L);
        totalSum.setDistrictAllocatedSum(7743888L);
        totalSum.setOtherFundsSum(4555002L);
        totalSum.setTotalFundsSum(23778892L);
        totalSum.setPurchaseMaintainSum(3547005L);
        totalSum.setPurchaseEquipmentSum(4867005L);
        totalSum.setDiseasePreventionSum(1925000L);
        totalSum.setExpertTrainingSum(2893001L);
        totalSum.setThirdPartyServiceSum(6037025L);
        totalSum.setOtherPaymentSum(1260005L);
        totalSum.setTotalPaymentSum(20529041L);
        totalSum.setCityRecoveredSum(1252000L);
        totalSum.setDistrictRecoveredSum(478000L);

        // 3. 封装结果（与实体类setter方法完全匹配）
        result.setIncomeExpenditureDetailVOList(detailVOList);
        result.setIncomeExpenditureTotalSum(totalSum);

        return result;
    }

    /**
     * 工具方法：构建IncomeExpenditureDetailVO对象，减少重复代码
     * 字段顺序与实体类属性顺序一致，便于核对
     */
    private static IncomeExpenditureDetailVO buildDetailVO(
            String id, String code, String district, Integer year,
            Long cityAllocated, Long districtAllocated, Long otherFunds, Long totalFunds,
            Long purchaseMaintain, Long purchaseEquipment, Long diseasePrevention, Long expertTraining,
            Long thirdPartyService, Long otherPayment, Long totalPayment,
            Long cityRecovered, Long districtRecovered,
            String createBy, Date createTime,
            String updateBy, Date updateTime) {

        IncomeExpenditureDetailVO vo = new IncomeExpenditureDetailVO();
        // 基础信息
        vo.setId(id);
        vo.setCode(code);
        vo.setDistrict(district);
        vo.setYear(year);
        // 经费来源
        vo.setCityAllocated(cityAllocated);
        vo.setDistrictAllocated(districtAllocated);
        vo.setOtherFunds(otherFunds);
        vo.setTotalFunds(totalFunds);
        // 已实际完成支付
        vo.setPurchaseMaintain(purchaseMaintain);
        vo.setPurchaseEquipment(purchaseEquipment);
        vo.setDiseasePrevention(diseasePrevention);
        vo.setExpertTraining(expertTraining);
        vo.setThirdPartyService(thirdPartyService);
        vo.setOtherPayment(otherPayment);
        vo.setTotalPayment(totalPayment);
        // 被收回资金
        vo.setCityRecovered(cityRecovered);
        vo.setDistrictRecovered(districtRecovered);
        // 操作信息
        vo.setCreateBy(createBy);
        vo.setCreateTime(createTime);
        vo.setUpdateBy(updateBy);
        vo.setUpdateTime(updateTime);
        return vo;
    }

    /**
     * 工具方法：日期字符串转Date（匹配实体类的@JsonFormat配置）
     */
    private static Date parseDate(String dateStr) throws ParseException {
        return DATE_FORMAT.parse(dateStr);
    }
}